[dbo].[BAEOrderSuperProductAttributeValueDelete]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderSuperProductAttributeValueDelete

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@OrderSuperProductAttributeValueID	int	4

create procedure [dbo].[BAEOrderSuperProductAttributeValueDelete] @OrderSuperProductAttributeValueID as
int
AS
    UPDATE OrderSuperProductAttributeValue SET SortOrder = SortOrder - 1 WHERE SortOrder > (SELECT SortOrder FROM OrderSuperProductAttributeValue
    WHERE OrderSuperProductAttributeValueID = @OrderSuperProductAttributeValueID);
    DELETE
    FROM OrderSuperProductAttributeValue
    WHERE OrderSuperProductAttributeValueID = @OrderSuperProductAttributeValueID;

GO